package com.acwer.drools.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.cache.annotation.CacheConfig;
import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Repository;

import com.acwer.drools.domain.Mcc;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

//@CacheConfig(cacheNames="MccDao")
//@Repository
//@Cacheable
public interface MccDao extends BaseMapper<Mcc>{

	
	@Select({  "<script>", 
		"select * from MCC mcc", 
		"where not exists (select 1 from except_table expt where expt.except_id=mcc.except_id and expt.jbbm =#{zzd}) and jbbm in",
			"<foreach collection='ls' open='(' close=')' item='id' index='i' separator=','>", "#{id}", "</foreach>",
			"</script>" 
		})
	public List<Mcc> selectDRGBylst(@Param("ls")List<String> ls,@Param("zzd")String zzd);
}
